


-----------------------------------------------

CREATE TABLE dbo.CLASSIF_FISCAL_ICMS (
           UF                                  CHAR(2)         NOT NULL,
           CLASSIF_FISCAL_INICIAL              CHAR(10)        NOT NULL,
           CLASSIF_FISCAL_FINAL                CHAR(10)        NOT NULL,
           ICMS_VENDA                          REAL            NULL,
           DATA_PARA_TRANSFERENCIA             DATETIME        NULL)
go

SP_BINDEFAULT 'DEFAULT_0', 'CLASSIF_FISCAL_ICMS.ICMS_VENDA'
go
SP_BINDEFAULT 'DATA_ATUAL', 'CLASSIF_FISCAL_ICMS.DATA_PARA_TRANSFERENCIA'
go

ALTER TABLE CLASSIF_FISCAL_ICMS ADD CONSTRAINT XPKCLASSIF_FISCAL_ICMS PRIMARY KEY (CLASSIF_FISCAL_INICIAL, CLASSIF_FISCAL_FINAL, UF)
go